forum

home / developersection / forums / how to select and retrieve data using linq query in entity framework

Ask Question

how to select and retrieve data using linq query in entity framework

Anonymous User 2061 21-Jan-2016
I want to  select and retrieve data using  linq query in entity framework how to do this please help me.
asp.net mvc linq  mvc  entity framework 
Updated on 21-Jan-2016
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

21-Jan-2016 


index.cshtml
@model IList<ForumMVC.CUSTOMER>
@{
    ViewBag.Title = "WebGrid CRUD Operations";   
}
<table style="background-color: #ccc; width: 100%;">
    <thead style="background-color: red;">
        <tr>
            <th>ID</th>
             <th>Name</th>
             <th>Phone</th>
             <th>Email</th>
             <th>Address</th>
        </tr>
    </thead>
    <tbody style="background-color: #ddd;">
        @foreach(var obj in Model)
        {
        <tr>
            <th>@obj.CUST_ID</th>
             <th>@obj.CUST_NAME</th>
             <th>@obj.CUST_PHONE</th>
             <th>@obj.CUST_EMAILID</th>
             <th>@obj.CUST_ADDRESS</th>
        </tr>
        }
    </tbody>
</table>
Controller
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using ForumMVC;
using System.Data.Entity;
using ForumMVC.Models;
namespace ForumMVC.Controllers
{
    public class HomeController : Controller
    {
        forumEntities1 db = new forumEntities1();
        public ActionResult Index()
        {
            IList<CUSTOMER> data = db.CUSTOMER.Where(p => p.CUST_ID < 70 && p.CUST_ID > 50).ToList();
            return View(data);
        }
    }
}

how to select and retrieve data using linq query in entity framework

 

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy